1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class ThucDonMod
15 {
16 protected string IdThucDon { get; set; }
17 protected string TenLoaiThucDon { get; set; }
18 protected string TenThucDon { get; set; }
19 protected string DonViTinh { get; set; }
20 protected float SoLuongTon {get;set;}
21 protected float DonGiaTon {get;set;}
22 protected float TonToiThieu {get;set;}
23 protected string TrangThai { get; set; }
24 public ThucDonMod(string _IdThucDon)
25 {
26 IdThucDon=_IdThucDon;
27 }
28 public ThucDonMod()
29 { }
30 public ThucDonMod(string _idThucdon,string _tenLoaithucdon,string _tenThucdon,string _donVitinh,float _soLuongton,float _donGiaton,float _tonToithieu,string _trangThai)
31 {
32 this.IdThucDon = _idThucdon;
33 this.TenLoaiThucDon = _tenLoaithucdon;
34 this.TenThucDon = _tenThucdon;
35 this.DonViTinh = _donVitinh;
36 this.SoLuongTon = _soLuongton;
37 this.DonGiaTon = _donGiaton;
38 this.TonToiThieu = _tonToithieu;
39 this.TrangThai = _trangThai;
40 }
41 public int InsertThucDon()
42 {
43 int i = 0;
44 string[] paras = new string[8] { "@IdThucDon","@TenLoaiThucDon","@TenThucDon","@DonViTinh","@SoLuongTon","@DonGiaTon","@TonToiThieu","@TrangThai" };
45 object[] values = new object[8] { IdThucDon, TenLoaiThucDon, TenThucDon, DonViTinh, SoLuongTon, DonGiaTon, TonToiThieu, TrangThai };
46 i = Models.connection.Excute_Sql("spInsertThucDon", CommandType.StoredProcedure, paras, values);
47 return i;
48 }
49 public int UpdateThucDon()
50 {
51 int i = 0;
52 string[] paras = new string[8] { "@IdThucDon", "@TenLoaiThucDon", "@TenThucDon", "@DonViTinh", "@SoLuongTon", "@DonGiaTon", "@TonToiThieu", "@TrangThai" };
53 object[] values = new object[8] { IdThucDon, TenLoaiThucDon, TenThucDon, DonViTinh, SoLuongTon, DonGiaTon, TonToiThieu, TrangThai };
54 i = Models.connection.Excute_Sql("spUpdateThucDon", CommandType.StoredProcedure, paras, values);
55 return i;
56 }
57 public int DeleteThucDon()
58 {
59 int i = 0;
60 string[] paras = new string[1] { "@IdThucDon" };
61 object[] values = new object[1] { IdThucDon };
62 i = Models.connection.Excute_Sql("spDeleteThucDon", CommandType.StoredProcedure, paras, values);
63 return i;
64 }
65 public static DataSet FillDataSetThucDon()
66 {
67 return Models.connection.FillDataSet("spgetThucDon", CommandType.StoredProcedure);
68 }
69 public static DataSet FillDataSetThucDonNotTTT()
70 {
71 return Models.connection.FillDataSet("spgetThucDonNotTTT", CommandType.StoredProcedure);
72 }
73 public DataSet FillDataSet_getLoaiThucDonByIdThucDon()
74 {
75 DataSet ds = new DataSet();
76 string[] paras = new string[1] { "@IdThucDon" };
77 object[] values = new object[1] { IdThucDon };
78 ds = Models.connection.FillDataSet("spgetThucDonByIdThucDon", CommandType.StoredProcedure, paras, values);
79 return ds;
80 }
81 }
82 }